<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html dir="ltr" xml:lang="en-gb" xmlns="http://www.w3.org/1999/xhtml"
	lang="en-gb">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
	<meta name="robots" content="index, follow">
		<meta name="keywords" content="joomla, Joomla">
			<meta name="description"
				content="Joomla! - the dynamic portal engine and content management system">
				<meta name="generator"
					content="Joomla! 1.5 - Open Source Content Management">
					<title>Welcome to the Mountain View Community Hospital</title>
					<link rel="stylesheet" href="../image/template.css" type="text/css">
						<link rel="stylesheet" href="../image/constant.css"
							type="text/css">

							<!--equal-->
							<!--[if IE]>
   <script type="text/javascript" src="/joomla_24417/templates/theme288/scripts/ie_png.js"></script>
   <script type="text/javascript">
       ie_png.fix('.png');
	</script>
<![endif]-->
</head>
<sql:setDataSource var="datas" driver="oracle.jdbc.driver.OracleDriver"
     url="jdbc:oracle:thin:@localhost:1521:orcl"
     user="dbfp_dba"  password="dbfpdba"/>

<sql:query dataSource="${datas}" var="resultSet" sql="SELECT * FROM outpatient_t"/>
<body id="body">
	<!--header-->
	<div class="tail-logo">
		<div class="tail-right"></div>
		<div class="main">
			<div class="row-logo">
				<h1 style="font-size: 30px; color: white;">Mountain View
					Community Hospital</h1>
			</div>
		</div>
	</div>
	<div class="tail-header">
		<div class="main">
			<div class="header">
				<div class="fright">
					<div class="row-1">
						<div class="moduletable">
							<img src="../image/header_link_img_1.gif" alt=""> <img
								src="../image/header_link_img_2.gif" alt=""> <img
									src="../image/header_link_img_3.gif" alt=""> <img
										src="../image/header_link_img_4.gif" alt=""> <img
											src="../image/header_link_img_5.gif" alt="">
						</div>
					</div>

				</div>

				<div class="clear1"></div>
			</div>
		</div>
	</div>
	<div class="tail-row-top-menu clear">
		<div class="main">
			<div class="row-top-menu clear">
				<div class="fright">
					<div class="module" style="text-align: right; margin-top: 15px;">
						<h4>${accountID},${role},${personID}<a href="/project/resources/common/login.htm">Logout</a></h4>


					</div>

				</div>
				<div class="fleft">
					<div class="module-search"></div>
				</div>
			</div>
		</div>
	</div>
	<div class="main">
		<div id="content">
			<div class="clear">
				<!--left-->
				<div id="left">
					<div class="left-indent">
						<div class="clear">
							<div class="wrapper-menu module_menu" style="padding: 0;">
								<div class="wrapper-menu-width">
									<div class="border-top">
										<div class="border-left">
											<div class="border-right">
												<div class="corner-top-left">
													<div class="corner-top-right">
														<table style="width: 100%;" class="width">
															<tbody>
																<tr>
																	<td class="width extra-height">
																		<div class="clear">
																			<div class="box-title">
																				<h3
																					style="padding: 27px 0 0 32px; color: #FFF; font-size: 14px; font-family: Georgia,"TimesNewRoman", Times, serif">Main
																					menu:</h3>
																			</div>
																			<div class="wrapper-menu-box">
																				<div class="clear">
																					<ul class="menu" style="padding: 0 32px 22px 31px">
																						<li class="item"><a
																							href="/project/resources/outpatient/viewPatient.jsp"><span>View Patient</span></a></li>
																						
																						<li class="item2"><a
																							href="/project/resources/outpatient/addVisit.html"><span>Add</span></a></li>
																						<li id="current" class="active item1"><a
																							href="/project/resources/outpatient/viewVisitHistory.jsp"><span>View</span></a></li>
																						
																						<li class="item3"><a
																							href="/project/resources/outpatient/deletepatient.jsp"><span>Delete Patient</span></a></li>
																						
																						</ul>
																				</div>
																			</div>
																		</div>
																	</td>
																</tr>
															</tbody>
														</table>
													</div>
												</div>
											</div>
										</div>
									</div>
								</div>
							</div>



						</div>
					</div>
				</div>
				<div id="container">
					<div class="container-indent">
						<div class="clear wrapper-box module-login">
							<div class="box-title" style="height: 50px">
								<div class="bull-title png" style="width: 450px; float: left;">
									<h3>Visit History Table</h3>
								</div>
								<div class="bull-title png"
									style="float: right; margin-top: 15px">
									
									<input name="Submit" class="button png" value="Back"
										type="submit" >
								</div>
							</div>
							<div class="box-indent">
								<div class="clear">

									<div>
										<table style="background-color: white; width: 900px; margin-top: 20px"
											borderColor="#aaaaaa" cellspacing="25" cellpadding="5"
											bgcolor="#eeeeee" border="10">
											<tr>
												
												<th style="width: 60px; ">Patient ID</th>
												<th style="width: 75px; ">Physician ID</th>
												<th style="width: 100px; ">Date</th>
												<th style="width: 50px; ">Fee</th>
												<th style="width: 100px; ">Discription</th>

											</tr>
											<c:forEach var="visit" items="${resultSet.rows}">
											<tr>
												<td>${visit.patient_id}</td>
												<td>${visit.physician_id}</td>
												<td>${visit.visit_date}</td>
												<td>${visit.visit_fee}</td>
												<td>${visit.physician_comment}</td>
											</tr>
											</c:forEach>
										</table>
									</div>
								</div>
							</div>

						</div>
					</div>
				</div>
			</div>
</body>
</html>
